Excel Freezing Panes

If you set up a worksheet with row or column headings, these headings will not be visible when you scroll down or to the right. MS Excel provides a tool to solve this problem with freezing panes. Freezing panes keeps the headings visible while you’re scrolling through the worksheet.

USING FREEZE PANES

Follow the below steps to do freeze panes


• Select the First row or First Column or row below are which you want to freeze or Column right to area which you want to freeze.
• Choose View Tab >> Freeze Panes.
• Select the appropriate as you need:
1. Freeze Panes: To freeze area of cells
2. Freeze Top Row: To freeze first row of worksheet
3. Freeze First Column: To freeze first Column of worksheet.

UNFREEZE PANES